PROMPT *-*-*-*-*-*-*-*-   CREATING cust_tb STARTS.... *-*-*-*-*-*-*-*-

DROP TABLE cust_tb
/

CREATE TABLE cust_tb 
(
  cust_id	NUMBER
, name		VARCHAR2(30)
, mobile	NUMBER(10)
, email		VARCHAR2(40)
, address	VARCHAR2(150)
)
/

PROMPT *-*-*-*-*-*-*-*-   CREATING cust_tb ENDS.... *-*-*-*-*-*-*-*-

PROMPT *-*-*-*-*-*-*-*-   CREATING inc_seq sequence STARTS.... *-*-*-*-*-*-*-*-

DROP SEQUENCE inc_seq;

CREATE SEQUENCE inc_seq
MINVALUE 1
MAXVALUE 99999999
START WITH 250
INCREMENT BY 1;

PROMPT *-*-*-*-*-*-*-*-   CREATING inc_seq sequence ENDS.... *-*-*-*-*-*-*-*-

PROMPT *-*-*-*-*-*-*-*-   INSERTING DATA into cust_tb STARTS.... *-*-*-*-*-*-*-*-

BEGIN
INSERT INTO cust_tb(   cust_id, name, mobile, email, address) 
             VALUES(1001 , 'Name_01',9898787865, 'name_01@gmail.com',NULL);
			 
INSERT INTO cust_tb(cust_id, name, mobile, email, address) 
			VALUES(1002 , 'Name_02',9898787866, 'name_02@gmail.com',NULL);

INSERT INTO cust_tb(cust_id, name, mobile, email, address) 
			VALUES(1003 , 'Name_03',9898787867, 'name_03@gmail.com',NULL);

INSERT INTO cust_tb(cust_id, name, mobile, email, address) 
             VALUES(1004 , 'Name_04',9898787868, 'name_04@gmail.com',NULL);

INSERT INTO cust_tb(cust_id, name, mobile, email, address) 
             VALUES(1005 , 'Name_05',9898787869, 'name_05@gmail.com',NULL);

COMMIT;
END;
/

PROMPT *-*-*-*-*-*-*-*-   CREATING inc_mgmt_tb STARTS.... *-*-*-*-*-*-*-*-

DROP TABLE inc_mgmt_tb;

CREATE TABLE inc_mgmt_tb
(
    ref_id        VARCHAR2(16)
  , cust_id		  NUMBER
  , mobile        NUMBER
  , issue_typ     VARCHAR2(10)
  , issue_desc    VARCHAR2(20)
  , status        VARCHAR2(3)
  , req_by		  VARCHAR2(10)
  , req_dttm      TIMESTAMP
  , apr_by        VARCHAR2(10)
  , apr_dttm      TIMESTAMP
  , rej_by        VARCHAR2(10)
  , rej_dttm      TIMESTAMP
  , rej_desc      VARCHAR2(10)
  , info_cng_num  NUMBER
);

PROMPT *-*-*-*-*-*-*-*-   CREATING inc_mgmt_tb ENDS.... *-*-*-*-*-*-*-*-